AutoAwardPaymentPlanSetting

EntityType | Independent
Logical Entity Name | AutoAwardPaymentPlanSetting
Default Table Name | FaCashPlanConfiguration
Logical Only | NO
Owner | dbo
Definition |
Note |

AutoAwardPaymentPlanSetting Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaCashPlanConfigurationId |  | INTEGER | NO |
Code |  | CHAR(8) | NO |
Descrip |  | VARCHAR(50) | NO |
RefundCalcPeriod |  | INTEGER | YES |
RefundCalcPeriodType |  | CHAR(1) | YES |
NoRefundCalcPeriod |  | INTEGER | YES |
NoRefundCalcPeriodType |  | CHAR(1) | YES |
FaFundSourceId |  | INTEGER | NO |
InterestRate |  | NUMERIC(5, 2) | YES |
DownPaymentFixedAmount |  | MONEY(19, 4) | YES |
DownPaymentBalancePercent |  | NUMERIC(5, 2) | YES |
MinPaymentAmount |  | MONEY(19, 4) | YES |
MaxNumOfPayment |  | INTEGER | YES |
PaymentFrequencyMonthly |  | TINYINT | YES |
PaymentFrequencyWeekly |  | TINYINT | YES |
CmDocTypeId |  | INTEGER | YES |
CustomPNTemplate |  | VARCHAR(50) | YES |
PrintCmTemplateId |  | INTEGER | YES |
EmailCmTemplateId |  | INTEGER | YES |
WebAlertCmTemplateId |  | INTEGER | YES |
PrintNotificationStaffId |  | INTEGER | YES |
PrintNotificationStaffGroupId |  | INTEGER | YES |
StatusType |  | CHAR(1) | YES |
UseForAutoAward |  | BIT | NO |
UserId |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
ts |  | TIMESTAMP/DATE | NO |

AutoAwardPaymentPlanSetting Keys

Key Name | Key Type | Keys
Uk_FaCashPlanConfiguration_Code | Alternate Key | Code
Nk_FaCashPlanConfiguration_PrintNotificationStaffGroupId | Inversion Entry | PrintNotificationStaffGroupId
Nk_FaCashPlanConfiguration_PrintNotificationStaffId | Inversion Entry | PrintNotificationStaffId
Nk_FaCashPlanConfiguration_UserId | Inversion Entry | UserId
PK_FaCashPlanConfiguration_FaCashPlanConfigurationId | PrimaryKey | FaCashPlanConfigurationId
Nk_FaCashPlanConfiguration_WebAlertCmTemplateId | Inversion Entry | WebAlertCmTemplateId
Nk_FaCashPlanConfiguration_EmailCmTemplateId | Inversion Entry | EmailCmTemplateId
Nk_FaCashPlanConfiguration_PrintCmTemplateId | Inversion Entry | PrintCmTemplateId
Nk_FaCashPlanConfiguration_CmDocTypeId | Inversion Entry | CmDocTypeId
Nk_FaCashPlanConfiguration_FaFundSourceId | Inversion Entry | FaFundSourceId

AutoAwardPaymentPlanSetting Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
DocumentType | Non-Identifying | Zero or One to Zero or More |  |  |  | CmDocTypeId | NO
TaskTemplate | Non-Identifying | Zero or One to Zero or More |  |  |  | EmailCmTemplateId | NO
FundSource | Non-Identifying | One To Zero or More |  |  |  | FaFundSourceId | NO
TaskTemplate | Non-Identifying | Zero or One to Zero or More |  |  |  | PrintCmTemplateId | NO
StaffGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | PrintNotificationStaffGroupId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | PrintNotificationStaffId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | UserId | NO
TaskTemplate | Non-Identifying | Zero or One to Zero or More |  |  |  | WebAlertCmTemplateId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
FaCashPlanConfigRelationship | Non-Identifying | One To Zero or More |  |  |  |  | NO
CampusAutoAwardSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO

AutoAwardPaymentPlanSetting Check Constraints

Check Constraint Name | CheckConstraint

AutoAwardPaymentPlanSetting Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.AutoAwardPaymentPlanSetting | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaCashPlanConfiguration | NO |  |  |

AutoAwardPaymentPlanSetting Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

AutoAwardPaymentPlanSetting Data Movement Rules

Name | Type | Rule Text/Value